<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateInvestorTable extends Migration {

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //投资人信息
        Schema::create('investor', function(Blueprint $table)
        {
            $table->increments('id');                           //编号
            $table->unsignedInteger('user_id')->default(0);     //用户ID
            $table->string('invest_log_id')->default(0);        //投资经历
            $table->unsignedInteger('org_id')->default(0);      //所属投资机构
            $table->integer('status')->default(0);              //投资者认证状态
            $table->string('invest_num_small')->nullable();     //投资金额（小）
            $table->string('invest_num_big')->nullable();       //投资金额（大）
            $table->softDeletes();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('investor');
    }

}
